PANIC: read of clog file 3165, offset 0 failed: Success

--_000_D78A8169F9436B4DB978300336168F3B3359AFE6C2SWBREXCH00u cs_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Please assist, I am getting the following error when trying to vacuum analy=
ze the database(database name db0532). It's PostgreSQL_7.3.4 running on Cen=
tOS5



db0532=3D# vacuum analyze;
PANIC: read of clog file 3165, offset 0 failed: Success
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.










Confidentiality Notice:http://ucs.co.za/conf.html



________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_D78A8169F9436B4DB978300336168F3B3359AFE6C2SWBREXCH00u cs_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"
" xmlns=3D"http://www.w3.org/TR/REC-html40">

>

Re: PANIC: read of clog file 3165, offset 0 failed: Success

I am not a member of the Postgres team and so I don't have any special=20
knowledge, but I can tell you two things for sure:

1) Version 7.3.4 is not supported any more, see:
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_P olicy

You should arrange to upgrade to a supported version as soon as=20
possible. Preferably to 8.4, but you would need to study the release=20
notes of each of the major releases in-between and see what=20
compatibility issues you would need to face. In particular, there was a=20
change in 8.3 regarding type-casting behavior that might require a=20
significant re-write of your applications.

2) The Postgres experts will need more information about your situation=20
in order to give you advice. For one thing, they will want to see the=20
contents of your $PGDATA/pg_clog directory. Issue the command "ls -l"=20
in that directory and capture the output.

Also, is it possible you are running out of disk space? Have there been=20
any other errors recently? Check your operating system logs.

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School



On 4/19/2010 3:17 AM, Khangelani Gama wrote:
> Please assist, I am getting the following error when trying to vacuum
> analyze the database(database name db0532). It=92s PostgreSQL_7.3.4
> running on CentOS5
>
> db0532=3D# vacuum analyze;
>
> *PANIC: read of clog file 3165, offset 0 failed: Success*
>
> server closed the connection unexpectedly
>
> This probably means the server terminated abnormally
>
> before or while processing the request.
>
> The connection to the server was lost. Attempting reset: Failed.
>
> * *
>
> Confidentiality Notice:http://ucs.co.za/conf.html
>
>
> ------------------------------------------------------------ -----------=
-
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of UCS
> Group and/or its subsidiaries. Any review, use or dissemination thereof
> by anyone other than the intended addressee is prohibited. If you are
> not the intended addressee please notify the writer immediately and
> destroy the e-mail. UCS Group Limited and its subsidiaries distance
> themselves from and accept no liability for unauthorised use of their
> e-mail facilities or e-mails sent other than strictly for business purp=
oses.


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: PANIC: read of clog file 3165, offset 0 failed:Success

Lewis Kapell wrote:
> I am not a member of the Postgres team and so I don't have any
> special knowledge, but I can tell you two things for sure:
>
> 1) Version 7.3.4 is not supported any more, see:
> http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_P olicy
>
> You should arrange to upgrade to a supported version as soon as
> possible.

Yeah, at least update to 7.3.21 which is not supported but has quite a
few bugs fixed -- and I think this misleading error message was fixed in
one of them.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin